using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
   public partial class VICC_HRPDC
    {
      #region======ColumnSchema==========
       /*
                public string HRITPNR { get { if (dwMaster == null) return ""; return dwMaster["HRITPNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRITPNR"] = value; OnPropertyChanged("HRITPNR", value); } } //lENGth 8
                public string HRBENID { get { if (dwMaster == null) return ""; return dwMaster["HRBENID"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRBENID"] = value; OnPropertyChanged("HRBENID", value); } } //lENGth 8
                public string HRVNAME { get { if (dwMaster == null) return ""; return dwMaster["HRVNAME"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRVNAME"] = value; OnPropertyChanged("HRVNAME", value); } } //lENGth 40
                public string HRNNAME { get { if (dwMaster == null) return ""; return dwMaster["HRNNAME"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRNNAME"] = value; OnPropertyChanged("HRNNAME", value); } } //lENGth 40
                public string ABFTYPE { get { if (dwMaster == null) return ""; return dwMaster["ABFTYPE"].ToString(); } set { if (dwMaster == null) return; dwMaster["ABFTYPE"] = value; OnPropertyChanged("ABFTYPE", value); } } //lENGth 15
                public string ABFAGANG { get { if (dwMaster == null) return ""; return dwMaster["ABFAGANG"].ToString(); } set { if (dwMaster == null) return; dwMaster["ABFAGANG"] = value; OnPropertyChanged("ABFAGANG", value); } } //lENGth 15
                public string ABFBZAGANG { get { if (dwMaster == null) return ""; return dwMaster["ABFBZAGANG"].ToString(); } set { if (dwMaster == null) return; dwMaster["ABFBZAGANG"] = value; OnPropertyChanged("ABFBZAGANG", value); } } //lENGth 60
                public string HRZART { get { if (dwMaster == null) return ""; return dwMaster["HRZART"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRZART"] = value; OnPropertyChanged("HRZART", value); } } //lENGth 1
                public string HRZARTDES { get { if (dwMaster == null) return ""; return dwMaster["HRZARTDES"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRZARTDES"] = value; OnPropertyChanged("HRZARTDES", value); } } //lENGth 10
                public string HRARTERL { get { if (dwMaster == null) return ""; return dwMaster["HRARTERL"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRARTERL"] = value; OnPropertyChanged("HRARTERL", value); } } //lENGth 1
                public string HRARTERLDES { get { if (dwMaster == null) return ""; return dwMaster["HRARTERLDES"].ToString(); } set { if (dwMaster == null) return; dwMaster["HRARTERLDES"] = value; OnPropertyChanged("HRARTERLDES", value); } } //lENGth 10
                public string ABPART { get { if (dwMaster == null) return ""; return dwMaster["ABPART"].ToString(); } set { if (dwMaster == null) return; dwMaster["ABPART"] = value; OnPropertyChanged("ABPART", value); } } //lENGth 20
                public string ABPFARBE { get { if (dwMaster == null) return ""; return dwMaster["ABPFARBE"].ToString(); } set { if (dwMaster == null) return; dwMaster["ABPFARBE"] = value; OnPropertyChanged("ABPFARBE", value); } } //lENGth 10
                public double GSGARNNR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSGARNNR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSGARNNR"] = value; OnPropertyChanged("GSGARNNR", value); } } //lENGth 0
                public string YCOUNTGROUP { get { if (dwMaster == null) return ""; return dwMaster["YCOUNTGROUP"].ToString(); } set { if (dwMaster == null) return; dwMaster["YCOUNTGROUP"] = value; OnPropertyChanged("YCOUNTGROUP", value); } } //lENGth 10
                public string COLORGROUP { get { if (dwMaster == null) return ""; return dwMaster["COLORGROUP"].ToString(); } set { if (dwMaster == null) return; dwMaster["COLORGROUP"] = value; OnPropertyChanged("COLORGROUP", value); } } //lENGth 10
                public double UNITPRICE { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["UNITPRICE"].ToString()); } set { if (dwMaster == null) return; dwMaster["UNITPRICE"] = value; OnPropertyChanged("UNITPRICE", value); } } //lENGth 0
                public double QTY { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["QTY"].ToString()); } set { if (dwMaster == null) return; dwMaster["QTY"] = value; OnPropertyChanged("QTY", value); } } //lENGth 0
                public double BSALARY { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BSALARY"].ToString()); } set { if (dwMaster == null) return; dwMaster["BSALARY"] = value; OnPropertyChanged("BSALARY", value); } } //lENGth 0
                public double WORKDAYS { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WORKDAYS"].ToString()); } set { if (dwMaster == null) return; dwMaster["WORKDAYS"] = value; OnPropertyChanged("WORKDAYS", value); } } //lENGth 0
                public double QTYADJUST { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["QTYADJUST"].ToString()); } set { if (dwMaster == null) return; dwMaster["QTYADJUST"] = value; OnPropertyChanged("QTYADJUST", value); } } //lENGth 0
                public double SALARY { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["SALARY"].ToString()); } set { if (dwMaster == null) return; dwMaster["SALARY"] = value; OnPropertyChanged("SALARY", value); } } //lENGth 0
                public double WORKSALARY { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WORKSALARY"].ToString()); } set { if (dwMaster == null) return; dwMaster["WORKSALARY"] = value; OnPropertyChanged("WORKSALARY", value); } } //lENGth 0
                public double BDAILY { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BDAILY"].ToString()); } set { if (dwMaster == null) return; dwMaster["BDAILY"] = value; OnPropertyChanged("BDAILY", value); } } //lENGth 0
                public double RDAILY { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["RDAILY"].ToString()); } set { if (dwMaster == null) return; dwMaster["RDAILY"] = value; OnPropertyChanged("RDAILY", value); } } //lENGth 0
                public string REMARK { get { if (dwMaster == null) return ""; return dwMaster["REMARK"].ToString(); } set { if (dwMaster == null) return; dwMaster["REMARK"] = value; OnPropertyChanged("REMARK", value); } } //lENGth 60
                public double BS00 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS00"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS00"] = value; OnPropertyChanged("BS00", value); } } //lENGth 0
                public double BS01 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS01"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS01"] = value; OnPropertyChanged("BS01", value); } } //lENGth 0
                public double BS02 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS02"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS02"] = value; OnPropertyChanged("BS02", value); } } //lENGth 0
                public double BS03 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS03"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS03"] = value; OnPropertyChanged("BS03", value); } } //lENGth 0
                public double BS04 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS04"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS04"] = value; OnPropertyChanged("BS04", value); } } //lENGth 0
                public double BS05 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS05"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS05"] = value; OnPropertyChanged("BS05", value); } } //lENGth 0
                public double BS06 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS06"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS06"] = value; OnPropertyChanged("BS06", value); } } //lENGth 0
                public double BS07 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS07"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS07"] = value; OnPropertyChanged("BS07", value); } } //lENGth 0
                public double BS08 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS08"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS08"] = value; OnPropertyChanged("BS08", value); } } //lENGth 0
                public double BS09 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS09"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS09"] = value; OnPropertyChanged("BS09", value); } } //lENGth 0
                public double BS10 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS10"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS10"] = value; OnPropertyChanged("BS10", value); } } //lENGth 0
                public double BS11 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS11"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS11"] = value; OnPropertyChanged("BS11", value); } } //lENGth 0
                public double BS12 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS12"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS12"] = value; OnPropertyChanged("BS12", value); } } //lENGth 0
                public double BS13 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS13"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS13"] = value; OnPropertyChanged("BS13", value); } } //lENGth 0
                public double BS14 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS14"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS14"] = value; OnPropertyChanged("BS14", value); } } //lENGth 0
                public double BS15 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS15"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS15"] = value; OnPropertyChanged("BS15", value); } } //lENGth 0
                public double BS16 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS16"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS16"] = value; OnPropertyChanged("BS16", value); } } //lENGth 0
                public double BS17 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS17"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS17"] = value; OnPropertyChanged("BS17", value); } } //lENGth 0
                public double BS18 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS18"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS18"] = value; OnPropertyChanged("BS18", value); } } //lENGth 0
                public double BS19 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS19"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS19"] = value; OnPropertyChanged("BS19", value); } } //lENGth 0
                public double BS20 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS20"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS20"] = value; OnPropertyChanged("BS20", value); } } //lENGth 0
                public double BS21 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS21"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS21"] = value; OnPropertyChanged("BS21", value); } } //lENGth 0
                public double BS22 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS22"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS22"] = value; OnPropertyChanged("BS22", value); } } //lENGth 0
                public double BS23 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS23"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS23"] = value; OnPropertyChanged("BS23", value); } } //lENGth 0
                public double BS24 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS24"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS24"] = value; OnPropertyChanged("BS24", value); } } //lENGth 0
                public double BS25 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS25"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS25"] = value; OnPropertyChanged("BS25", value); } } //lENGth 0
                public double BS26 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS26"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS26"] = value; OnPropertyChanged("BS26", value); } } //lENGth 0
                public double BS27 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS27"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS27"] = value; OnPropertyChanged("BS27", value); } } //lENGth 0
                public double BS28 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS28"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS28"] = value; OnPropertyChanged("BS28", value); } } //lENGth 0
                public double BS29 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS29"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS29"] = value; OnPropertyChanged("BS29", value); } } //lENGth 0
                public double BS30 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS30"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS30"] = value; OnPropertyChanged("BS30", value); } } //lENGth 0
                public double BS31 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS31"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS31"] = value; OnPropertyChanged("BS31", value); } } //lENGth 0
                public double BS32 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS32"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS32"] = value; OnPropertyChanged("BS32", value); } } //lENGth 0
                public double BS33 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS33"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS33"] = value; OnPropertyChanged("BS33", value); } } //lENGth 0
                public double BS34 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS34"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS34"] = value; OnPropertyChanged("BS34", value); } } //lENGth 0
                public double BS35 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS35"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS35"] = value; OnPropertyChanged("BS35", value); } } //lENGth 0
                public double BS36 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS36"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS36"] = value; OnPropertyChanged("BS36", value); } } //lENGth 0
                public double BS37 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS37"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS37"] = value; OnPropertyChanged("BS37", value); } } //lENGth 0
                public double BS38 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS38"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS38"] = value; OnPropertyChanged("BS38", value); } } //lENGth 0
                public double BS39 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS39"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS39"] = value; OnPropertyChanged("BS39", value); } } //lENGth 0
                public double BS40 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS40"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS40"] = value; OnPropertyChanged("BS40", value); } } //lENGth 0
                public double BS41 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS41"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS41"] = value; OnPropertyChanged("BS41", value); } } //lENGth 0
                public double BS42 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS42"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS42"] = value; OnPropertyChanged("BS42", value); } } //lENGth 0
                public double BS43 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS43"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS43"] = value; OnPropertyChanged("BS43", value); } } //lENGth 0
                public double BS44 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS44"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS44"] = value; OnPropertyChanged("BS44", value); } } //lENGth 0
                public double BS45 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS45"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS45"] = value; OnPropertyChanged("BS45", value); } } //lENGth 0
                public double BS46 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS46"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS46"] = value; OnPropertyChanged("BS46", value); } } //lENGth 0
                public double BS47 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS47"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS47"] = value; OnPropertyChanged("BS47", value); } } //lENGth 0
                public double BS48 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS48"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS48"] = value; OnPropertyChanged("BS48", value); } } //lENGth 0
                public double BS49 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS49"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS49"] = value; OnPropertyChanged("BS49", value); } } //lENGth 0
                public double BS50 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS50"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS50"] = value; OnPropertyChanged("BS50", value); } } //lENGth 0
                public double BS51 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS51"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS51"] = value; OnPropertyChanged("BS51", value); } } //lENGth 0
                public double BS52 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS52"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS52"] = value; OnPropertyChanged("BS52", value); } } //lENGth 0
                public double BS53 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS53"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS53"] = value; OnPropertyChanged("BS53", value); } } //lENGth 0
                public double BS54 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS54"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS54"] = value; OnPropertyChanged("BS54", value); } } //lENGth 0
                public double BS55 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS55"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS55"] = value; OnPropertyChanged("BS55", value); } } //lENGth 0
                public double BS56 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS56"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS56"] = value; OnPropertyChanged("BS56", value); } } //lENGth 0
                public double BS57 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS57"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS57"] = value; OnPropertyChanged("BS57", value); } } //lENGth 0
                public double BS58 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS58"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS58"] = value; OnPropertyChanged("BS58", value); } } //lENGth 0
                public double BS59 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS59"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS59"] = value; OnPropertyChanged("BS59", value); } } //lENGth 0
                public double BS60 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS60"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS60"] = value; OnPropertyChanged("BS60", value); } } //lENGth 0
                public double BS99 { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["BS99"].ToString()); } set { if (dwMaster == null) return; dwMaster["BS99"] = value; OnPropertyChanged("BS99", value); } } //lENGth 0
       */
       #endregion
    } 
}
